package com.byxy.computer.student.dao;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.byxy.computer.student.entity.Student;

@Repository
public interface StudentDao extends JpaRepository<Student, String> {

	@Query("select count(u) from Student u where u.stats='√' or u.stats='C'")
	public int countArrive();
	@Query("select count(u) from Student u where u.homework is not null")
	public int countHomeWork();

}
